Harold_Shipman_mug_shot.jpg

Harold Frederick Shipman, Jr. (14 January 1946 – 13 January 2004), known to acquaintances as Fred Shipman, was an English general practitioner and serial killer. He is considered to be one of the most prolific serial killers in modern history, with an estimated 250 victims. On 31 January 2000, Shipman was found guilty of murdering fifteen patients under his care. He was sentenced to life imprisonment with a whole life order. Shipman died by suicide by hanging himself in his cell at HM Prison Wakefield, West Yorkshire, on 13 January 2004, aged 57. More details here: https://en.wikipedia.org/wiki/Harold_Shipman

.........Loading Everything for our analysis.

In [1]:
import pyodbc
import pandas as pd
import numpy as np
from matplotlib import pyplot as plt
from IPython.display import display
import plotly.graph_objects as go
import numpy as np
import sqlalchemy as sa
import warnings

warnings.filterwarnings('ignore')

pd.options.display.max_rows = None
pd.options.display.max_columns = None

try:
    server  = 'DESKTOP-7AVUQ5G'
    database = 'practical_sql'
    trusted_connection = 'yes'
    driver = 'SQL Server'
    pd.set_option('display.max_columns', None)
    conn = pyodbc.connect(f'Driver={driver};'
                        f'Server={server};'
                        f'Database={database};'
                        f'Trusted_Connection={trusted_connection};')

    cursor = conn.cursor()
    print("Everything is working as expected")

except:
    print("Oops, something went wrong!")
Everything is working as expected
In [2]:
pd.options.display.max_rows = None
pd.options.display.max_columns = None
query = """
SELECT *
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]

  
 

"""
df = pd.read_sql_query(query, conn)


df
Out[2]:
DateofDeath Name Age PlaceofDeath Decision yearOfDeath gender fractionalDeathYear ageBracket gender2
0 1975-03-17 Eva Lyons 70 Own home Unlawful killing 1975 False 1974.709961 70-74 Women
1 1978-08-07 Sarah Hannah Marsland 86 Own home Unlawful killing 1978 False 1978.099976 85-89 Women
2 1978-08-30 Mary Ellen Jordan 73 Own home Unlawful killing 1978 False 1978.160034 70-74 Women
3 1978-12-07 Harold Bramwell 73 Own home Unlawful killing 1978 True 1978.439941 70-74 Men
4 1978-12-20 Annie Campbell 88 Own home Unlawful killing 1978 False 1978.469971 85-89 Women
5 1979-08-10 Alice Maude Gorton 76 Own home Unlawful killing 1979 False 1979.109985 75-79 Women
6 1979-11-28 Jack Leslie Shelmerdine 77 Hospital Unlawful killing 1979 True 1979.410034 75-79 Men
7 1981-04-18 May Slater 84 Own home Unlawful killing 1981 False 1980.800049 80-84 Women
8 1981-08-26 Elizabeth Ashworth 81 Own home Unlawful killing 1981 False 1981.150024 80-84 Women
9 1983-01-04 Percy Ward 90 Own home Unlawful killing 1983 True 1982.510010 90-94 Men
10 1983-06-28 Moira Ashton Fox 77 Own home Unlawful killing 1983 False 1982.989990 75-79 Women
11 1984-01-07 Dorothy Tucker 51 Own home Unlawful killing 1984 False 1983.520020 50-54 Women
12 1984-02-08 Gladys Roberts 78 Own home Unlawful killing 1984 False 1983.609985 75-79 Women
13 1984-04-15 Joseph Bardsley 83 Own home Unlawful killing 1984 True 1983.790039 80-84 Men
14 1984-04-24 Winifred Arrowsmith 70 Own home Unlawful killing 1984 False 1983.810059 70-74 Women
15 1984-09-21 Mary Winterbottom 76 Own home Unlawful killing 1984 False 1984.219971 75-79 Women
16 1984-11-27 Ada Ashworth 87 Own home Unlawful killing 1984 False 1984.410034 85-89 Women
17 1984-12-17 Joseph Vincent Everall 80 Own home Unlawful killing 1984 True 1984.459961 80-84 Men
18 1984-12-18 Edith Wibberley 76 Own home Unlawful killing 1984 False 1984.469971 75-79 Women
19 1984-12-24 Eileen Theresa Cox 72 Own home Unlawful killing 1984 False 1984.479980 70-74 Women
20 1985-01-02 Peter Lewis 41 Own home Unlawful killing 1985 True 1984.510010 40-44 Men
21 1985-02-01 May Brookes 74 Own home Unlawful killing 1985 False 1984.589966 70-74 Women
22 1985-02-04 Ellen Higson 84 Own home Unlawful killing 1985 False 1984.599976 80-84 Women
23 1985-02-15 Margaret Ann Conway 69 Own home Unlawful killing 1985 False 1984.630005 65-69 Women
24 1985-02-22 Kathleen McDonald 73 Own home Unlawful killing 1985 False 1984.650024 70-74 Women
25 1985-06-26 Thomas Moult 70 Own home Unlawful killing 1985 True 1984.989990 70-74 Men
26 1985-06-26 Mildred Robinson 84 Own home Unlawful killing 1985 False 1984.989990 80-84 Women
27 1985-08-23 Frances Elizabeth Turner 85 Own home Unlawful killing 1985 False 1985.150024 85-89 Women
28 1985-12-17 Selina Mackenzie 77 Own home Unlawful killing 1985 False 1985.459961 75-79 Women
29 1985-12-20 Vera Bramwell 79 Own home Unlawful killing 1985 False 1985.469971 75-79 Women
30 1985-12-31 Fred Kellett 79 Own home Unlawful killing 1985 True 1985.500000 75-79 Men
31 1986-01-07 Deborah Middleton 81 Own home Unlawful killing 1986 False 1985.520020 80-84 Women
32 1986-04-23 Dorothy Fletcher 74 Residential Home Unlawful killing 1986 False 1985.810059 70-74 Women
33 1986-06-06 Thomas Fowden 81 Own home Unlawful killing 1986 True 1985.930054 80-84 Men
34 1986-09-15 Mona Ashton White 63 Own home Unlawful killing 1986 False 1986.209961 60-64 Women
35 1986-10-07 Mary Tomlin 73 Own home Unlawful killing 1986 False 1986.270020 70-74 Women
36 1986-11-17 Beatrice Toft 59 Own home Unlawful killing 1986 False 1986.380005 55-59 Women
37 1986-12-16 Lily Broadbent 75 Own home Unlawful killing 1986 False 1986.459961 75-79 Women
38 1986-12-23 James Wood 82 Own home Unlawful killing 1986 True 1986.479980 80-84 Men
39 1987-03-30 Frank Halliday 76 Own home Unlawful killing 1987 True 1986.750000 75-79 Men
40 1987-04-01 Albert Cheetham 85 Own home Unlawful killing 1987 True 1986.750000 85-89 Men
41 1987-04-16 Alice Thomas 83 Own home Unlawful killing 1987 False 1986.790039 80-84 Women
42 1987-05-08 Jane Frances Rostron 78 Own home Unlawful killing 1987 False 1986.849976 75-79 Women
43 1987-09-14 Nancy Anne Brassington 71 Own home Unlawful killing 1987 False 1987.209961 70-74 Women
44 1987-12-11 Margaret Townsend 80 Own home Unlawful killing 1987 False 1987.449951 80-84 Women
45 1987-12-29 Nellie Bardsley 69 Own home Unlawful killing 1987 False 1987.500000 65-69 Women
46 1987-12-30 Elizabeth Ann Rogers 74 Own home Unlawful killing 1987 False 1987.500000 70-74 Women
47 1988-01-05 Elizabeth Fletcher 90 Own home Unlawful killing 1988 False 1987.510010 90-94 Women
48 1988-01-15 Alice Mary Jones 83 Own home Unlawful killing 1988 False 1987.540039 80-84 Women
49 1988-02-09 Dorothea Hill Renwick 90 Own home Unlawful killing 1988 False 1987.609985 90-94 Women
50 1988-02-15 Ann Cooper 93 Own home Unlawful killing 1988 False 1987.619995 90-94 Women
51 1988-02-15 Jane Jones 83 Own home Unlawful killing 1988 False 1987.619995 80-84 Women
52 1988-02-16 Lavinia Robinson 84 Own home Unlawful killing 1988 False 1987.630005 80-84 Women
53 1988-09-18 Rose Ann Adshead 80 Own home Unlawful killing 1988 False 1988.219971 80-84 Women
54 1988-10-20 Alice Prestwich 69 Own home Unlawful killing 1988 False 1988.300049 65-69 Women
55 1988-11-06 Walter Tingle 85 Own home Unlawful killing 1988 True 1988.349976 85-89 Men
56 1988-12-17 Harry Stafford 87 Own home Unlawful killing 1988 True 1988.459961 85-89 Men
57 1988-12-19 Ethel Bennett 80 Own home Unlawful killing 1988 False 1988.469971 80-84 Women
58 1989-01-31 Wilfred Chappell 80 Own home Unlawful killing 1989 False 1988.589966 80-84 Women
59 1989-03-08 Mary Emma Hamer 81 Shipman's surgery Unlawful killing 1989 False 1988.680054 80-84 Women
60 1989-05-12 Beatrice Helen Clee 78 Own home Unlawful killing 1989 False 1988.859985 75-79 Women
61 1989-06-05 Josephine Hall 69 Own home Unlawful killing 1989 False 1988.930054 65-69 Women
62 1989-07-06 Hilda Fitton 75 Own home Unlawful killing 1989 False 1989.010010 75-79 Women
63 1989-08-14 Marion Carradice 80 Own home Unlawful killing 1989 False 1989.119995 80-84 Women
64 1989-09-22 Elsie Harrop 82 Own home Unlawful killing 1989 False 1989.229980 80-84 Women
65 1989-09-26 Elizabeth Mary Burke 82 Own home Unlawful killing 1989 False 1989.239990 80-84 Women
66 1989-10-15 Sarah Jane Williamson 82 Own home Unlawful killing 1989 False 1989.290039 80-84 Women
67 1989-10-16 John Charlton 81 Own home Unlawful killing 1989 True 1989.290039 80-84 Men
68 1989-10-18 George Edgar Vizor 67 Own home Unlawful killing 1989 True 1989.300049 65-69 Men
69 1989-11-06 Joseph Frank Wilcockson 85 Own home Unlawful killing 1989 True 1989.349976 85-89 Men
70 1990-09-18 Dorothy Rowarth 56 Own home Unlawful killing 1990 False 1990.219971 55-59 Women
71 1990-12-30 Mary Rose Dudley 69 Own home Unlawful killing 1990 False 1990.500000 65-69 Women
72 1992-10-07 Monica Rene Sparkes 72 Own home Unlawful killing 1992 False 1992.270020 70-74 Women
73 1993-02-24 Olive Heginbotham 86 Own home Unlawful killing 1993 False 1992.650024 85-89 Women
74 1993-02-24 Hilda Mary Couzens 92 Own home Unlawful killing 1993 False 1992.650024 90-94 Women
75 1993-03-22 Amy Whitehead 82 Own home Unlawful killing 1993 False 1992.719971 80-84 Women
76 1993-04-08 Mary Emma Andrew 86 Own home Unlawful killing 1993 False 1992.770020 85-89 Women
77 1993-04-17 Sarah Ashworth 74 Own home Unlawful killing 1993 False 1992.790039 70-74 Women
78 1993-04-26 Fanny Nichols 84 Own home Unlawful killing 1993 False 1992.819946 80-84 Women
79 1993-04-27 Marjorie Parker 74 Own home Unlawful killing 1993 False 1992.819946 70-74 Women
80 1993-05-02 Nellie Mullen 77 Own home Unlawful killing 1993 False 1992.839966 75-79 Women
81 1993-05-04 Edna May Llewellyn 68 Own home Unlawful killing 1993 False 1992.839966 65-69 Women
82 1993-05-12 Emily Morgan 84 Own home Unlawful killing 1993 False 1992.859985 80-84 Women
83 1993-05-13 Violet May Bird 60 Own home Unlawful killing 1993 False 1992.869995 60-64 Women
84 1993-07-22 Jose Kathleen Diana Richards 74 Own home Unlawful killing 1993 False 1993.060059 70-74 Women
85 1993-08-16 Edith Calverley 77 Own home Unlawful killing 1993 False 1993.130005 75-79 Women
86 1993-12-16 Joseph Leigh 78 Own home Unlawful killing 1993 False 1993.459961 75-79 Women
87 1993-12-22 Eileen Robinson 54 Own home Unlawful killing 1993 False 1993.479980 50-54 Women
88 1993-12-31 Charles Edward Brocklehurst 90 Own home Unlawful killing 1993 True 1993.500000 90-94 Men
89 1994-01-04 Joan Milray Harding 82 Shipman's surgery Unlawful killing 1994 False 1993.510010 80-84 Women
90 1994-01-13 Christine Hancock 53 Own home Unlawful killing 1994 False 1993.540039 50-54 Women
91 1994-02-09 Elsie Platt 73 Own home Unlawful killing 1994 False 1993.609985 70-74 Women
92 1994-05-17 Mary Alice Smith 84 Own home Unlawful killing 1994 False 1993.880005 80-84 Women
93 1994-05-25 Ronnie Devenport 57 Own home Unlawful killing 1994 False 1993.900024 55-59 Women
94 1994-06-15 Cicely Sharples 87 Own home Unlawful killing 1994 False 1993.959961 85-89 Women
95 1994-06-17 Alice Christine Kitchen 70 Own home Unlawful killing 1994 False 1993.959961 70-74 Women
96 1994-07-27 Maria Thornton 78 Own home Unlawful killing 1994 False 1994.069946 75-79 Women
97 1994-11-25 Henrietta Walker 87 Own home Unlawful killing 1994 False 1994.400024 85-89 Women
98 1994-11-30 Elizabeth Ellen Mellor 75 Own home Unlawful killing 1994 False 1994.420044 75-79 Women
99 1994-12-29 John Bennett Molesdale 81 Own home Unlawful killing 1994 False 1994.500000 80-84 Women
100 1995-01-09 Alice Kennedy 88 Own home Unlawful killing 1995 False 1994.530029 85-89 Women
101 1995-03-01 Lucy Virgin 70 Own home Unlawful killing 1995 False 1994.670044 70-74 Women
102 1995-03-03 Joseph Shaw 88 Own home Unlawful killing 1995 True 1994.670044 85-89 Men
103 1995-03-06 Maria West 81 Own home Conviction 1995 False 1994.680054 80-84 Women
104 1995-03-07 Netta Ashcroft 71 Own home Unlawful killing 1995 False 1994.680054 70-74 Women
105 1995-03-07 Lily Bardsley 88 Own home Unlawful killing 1995 False 1994.680054 85-89 Women
106 1995-03-13 Marie Antoinette Fernley 53 Own home Unlawful killing 1995 False 1994.699951 50-54 Women
107 1995-03-21 John Crompton 82 Own home Unlawful killing 1995 True 1994.719971 80-84 Men
108 1995-03-26 Frank Crompton 86 Own home Unlawful killing 1995 True 1994.729980 85-89 Men
109 1995-03-31 Vera Brocklehurst 70 Own home Unlawful killing 1995 False 1994.750000 70-74 Women
110 1995-04-10 Angela Philomena Tierney 71 Own home Unlawful killing 1995 False 1994.780029 70-74 Women
111 1995-04-13 Edith Scott 85 Own home Unlawful killing 1995 False 1994.780029 85-89 Women
112 1995-04-14 Clara Hackney 84 Own home Unlawful killing 1995 False 1994.790039 80-84 Women
113 1995-04-21 Renate Eldtraude Overton 47 Hospital Unlawful killing 1995 False 1994.810059 45-49 Women
114 1995-05-04 Kate Maud Sellors 75 Own home Unlawful killing 1995 False 1994.839966 75-79 Women
115 1995-06-02 Clifford Barnes Heapey 85 Nursing home Unlawful killing 1995 True 1994.920044 85-89 Men
116 1995-06-13 Bertha Moss 68 Shipman's surgery Unlawful killing 1995 False 1994.949951 65-69 Women
117 1995-06-17 Brenda Ashworth 63 Own home Unlawful killing 1995 False 1994.959961 60-64 Women
118 1995-06-29 Ernest Rudol 82 Own home Unlawful killing 1995 False 1994.989990 80-84 Women
119 1995-07-12 Ada Matley Hilton 88 Own home Unlawful killing 1995 False 1995.030029 85-89 Women
120 1995-07-31 Irene Aitken 65 Own home Unlawful killing 1995 False 1995.079956 65-69 Women
121 1995-08-29 Arthur Henderson Stopford 82 Own home Unlawful killing 1995 True 1995.160034 80-84 Men
122 1995-09-14 Geoffrey Bogle 72 Own home Unlawful killing 1995 True 1995.209961 70-74 Men
123 1995-09-26 Dora Elizabeth Ashton 87 Shipman's surgery Unlawful killing 1995 False 1995.239990 85-89 Women
124 1995-10-24 Muriel Margaret Ward 87 Own home Unlawful killing 1995 False 1995.319946 85-89 Women
125 1995-11-08 Edith Brock 74 Own home Unlawful killing 1995 False 1995.359985 70-74 Women
126 1995-11-22 Charles Henry Barlow 88 Own home Unlawful killing 1995 True 1995.390015 85-89 Men
127 1995-11-25 Konrad Peter Ovcar-Robinson 43 Own home Unlawful killing 1995 True 1995.400024 40-44 Men
128 1995-12-14 Elizabeth Teresa Sigley 67 Own home Unlawful killing 1995 False 1995.449951 65-69 Women
129 1995-12-14 Kenneth Wharmby Woodhead 75 Own home Unlawful killing 1995 True 1995.449951 75-79 Men
130 1996-01-02 Hilda Mary Hibbert 81 Own home Unlawful killing 1996 False 1995.500000 80-84 Women
131 1996-01-11 Erla Copeland 79 Own home Unlawful killing 1996 False 1995.530029 75-79 Women
132 1996-02-21 Jane Elizabeth Shelmerdine 80 Own home Unlawful killing 1996 False 1995.640015 80-84 Women
133 1996-02-27 John Sheard Greenhalgh 88 Own home Unlawful killing 1996 True 1995.660034 85-89 Men
134 1996-03-12 Minnie Doris Irene Galpin 71 Own home Unlawful killing 1996 False 1995.699951 70-74 Women
135 1996-04-18 Marjorie Hope Waller 79 Own home Unlawful killing 1996 False 1995.800049 75-79 Women
136 1996-04-24 John Stone 77 Own home Unlawful killing 1996 True 1995.810059 75-79 Men
137 1996-05-07 Elsie Godfrey 85 Own home Unlawful killing 1996 False 1995.849976 85-89 Women
138 1996-05-13 Edith Brady 72 Shipman's surgery Unlawful killing 1996 False 1995.869995 70-74 Women
139 1996-05-29 Valerie Cuthbert 54 Own home Unlawful killing 1996 False 1995.910034 50-54 Women
140 1996-05-30 Lilian Cullen 77 Own home Unlawful killing 1996 False 1995.910034 75-79 Women
141 1996-06-06 Renee Lacey 63 Own home Unlawful killing 1996 False 1995.930054 60-64 Women
142 1996-06-10 Leah Fogg 82 Own home Unlawful killing 1996 False 1995.939941 80-84 Women
143 1996-06-17 Gladys Saunders 82 Own home Unlawful killing 1996 False 1995.959961 80-84 Women
144 1996-06-25 Nellie Bennett 86 Own home Unlawful killing 1996 False 1995.979980 85-89 Women
145 1996-06-25 Margaret Mary Vickers 81 Own home Unlawful killing 1996 False 1995.979980 80-84 Women
146 1996-07-02 Tom Balfour Russell 77 Own home Unlawful killing 1996 True 1996.000000 75-79 Men
147 1996-07-11 Irene Turner 67 Own home Conviction 1996 False 1996.030029 65-69 Women
148 1996-07-16 Carrie Leigh 81 Own home Unlawful killing 1996 False 1996.040039 80-84 Women
149 1996-07-19 Marion Elizabeth Higham 84 Own home Unlawful killing 1996 False 1996.050049 80-84 Women
150 1996-07-24 Elsie Hannible 85 Own home Unlawful killing 1996 False 1996.060059 85-89 Women
151 1996-07-29 Elsie Barker 84 Own home Unlawful killing 1996 False 1996.079956 80-84 Women
152 1996-08-30 Sidney Arthur Smith 76 Own home Unlawful killing 1996 True 1996.160034 75-79 Men
153 1996-09-12 Dorothy Mary Andrew 85 Own home Unlawful killing 1996 False 1996.199951 85-89 Women
154 1996-09-20 Anne Lilian Ralphs 75 Own home Unlawful killing 1996 False 1996.219971 75-79 Women
155 1996-10-23 Millicent Garside 76 Own home Unlawful killing 1996 False 1996.310059 75-79 Women
156 1996-11-20 Irene Heathcote 76 Own home Unlawful killing 1996 False 1996.390015 75-79 Women
157 1996-11-23 Samuel Mills 89 Own home Unlawful killing 1996 False 1996.400024 85-89 Women
158 1996-12-04 Thomas Cheetham 78 Own home Unlawful killing 1996 True 1996.430054 75-79 Men
159 1996-12-17 Kenneth Ernest Smith 73 Own home Unlawful killing 1996 True 1996.459961 70-74 Men
160 1997-01-02 Eileen Daphne Crompton 75 Residential home Unlawful killing 1997 False 1996.510010 75-79 Women
161 1997-01-03 David Alan Harrison 47 Own home Unlawful killing 1997 True 1996.510010 45-49 Men
162 1997-01-08 Elsie Lorna Dean 69 Own home Unlawful killing 1997 False 1996.520020 65-69 Women
163 1997-01-20 Irene Brooder 76 Own home Unlawful killing 1997 False 1996.560059 75-79 Women
164 1997-01-27 Charlotte Bennison 89 Own home Unlawful killing 1997 False 1996.579956 85-89 Women
165 1997-02-03 Charles Henry Killan 90 Own home Unlawful killing 1997 False 1996.589966 90-94 Women
166 1997-02-04 Betty Royston 70 Own home Unlawful killing 1997 False 1996.599976 70-74 Women
167 1997-02-23 Joyce Woodhead 74 Own home Unlawful killing 1997 False 1996.650024 70-74 Women
168 1997-02-28 Lizzie Adams 77 Own home Conviction 1997 False 1996.660034 75-79 Women
169 1997-03-22 Rose Garlick 76 Own home Unlawful killing 1997 False 1996.719971 75-79 Women
170 1997-03-27 May Lowe 84 Own home Unlawful killing 1997 False 1996.739990 80-84 Women
171 1997-04-21 Mary Coutts 80 Own home Unlawful killing 1997 False 1996.810059 80-84 Women
172 1997-04-25 Elsie Cheetham 76 Own home Unlawful killing 1997 False 1996.819946 75-79 Women
173 1997-04-25 Jean Lilley 58 Own home Conviction 1997 False 1996.819946 55-59 Women
174 1997-05-02 Lena Norah Slater 68 Own home Unlawful killing 1997 False 1996.839966 65-69 Women
175 1997-05-12 Ethel May Kellett 74 Own home Unlawful killing 1997 False 1996.859985 70-74 Women
176 1997-05-21 Doris Earls 79 Own home Unlawful killing 1997 False 1996.890015 75-79 Women
177 1997-05-29 Ivy Lomas 63 Shipman's surgery Conviction 1997 False 1996.910034 60-64 Women
178 1997-06-24 Vera Whittingslow 69 Own home Unlawful killing 1997 False 1996.979980 65-69 Women
179 1997-07-07 Maureen Lamonnier Jackson 51 Own home Unlawful killing 1997 False 1997.020020 50-54 Women
180 1997-07-14 Muriel Grimshaw 76 Own home Conviction 1997 False 1997.040039 75-79 Women
181 1997-07-25 John Louden Livesey 69 Own home Unlawful killing 1997 True 1997.069946 65-69 Men
182 1997-07-28 Lily Newby Taylor 86 Own home Unlawful killing 1997 False 1997.069946 85-89 Women
183 1997-08-10 Dorothy Doretta Hopkins 72 Own home Unlawful killing 1997 False 1997.109985 70-74 Women
184 1997-09-01 Nancy Jackson 81 Own home Unlawful killing 1997 False 1997.170044 80-84 Women
185 1997-09-22 Mavis Mary Pickup 79 Own home Unlawful killing 1997 False 1997.229980 75-79 Women
186 1997-09-26 Bessie Swann 79 Own home Unlawful killing 1997 False 1997.239990 75-79 Women
187 1997-09-29 Enid Otter 77 Own home Unlawful killing 1997 False 1997.250000 75-79 Women
188 1997-11-10 Florence Lewis 79 Own home Unlawful killing 1997 False 1997.359985 75-79 Women
189 1997-11-14 Mary Walls 78 Own home Unlawful killing 1997 False 1997.369995 75-79 Women
190 1997-11-21 Elizabeth Mary Baddeley 83 Own home Unlawful killing 1997 False 1997.390015 80-84 Women
191 1997-11-24 Marie Quinn 67 Own home Conviction 1997 False 1997.400024 65-69 Women
192 1997-12-08 Elizabeth Battersby 70 Own home Unlawful killing 1997 False 1997.439941 70-74 Women
193 1997-12-09 Laura Kathleen Wagstaff 81 Own home Conviction 1997 False 1997.439941 80-84 Women
194 1997-12-10 Bianka Pomfret 49 Own home Conviction 1997 False 1997.439941 45-49 Women
195 1997-12-18 Alice Black 73 Own home Unlawful killing 1997 False 1997.469971 70-74 Women
196 1997-12-24 James Joseph King 83 Own home Unlawful killing 1997 True 1997.479980 80-84 Men
197 1998-01-22 Mabel Shawcross 79 Own home Unlawful killing 1998 False 1997.560059 75-79 Women
198 1998-01-26 Norah Nuttall 64 Own home Conviction 1998 False 1997.569946 60-64 Women
199 1998-02-02 Cissie Davies 73 Own home Unlawful killing 1998 False 1997.589966 70-74 Women
200 1998-02-09 Pamela Marguerite Hillier 68 Own home Conviction 1998 False 1997.609985 65-69 Women
201 1998-02-13 Laura Frances Linn 83 Own home Unlawful killing 1998 False 1997.619995 80-84 Women
202 1998-02-15 Irene Berry 74 Own home Unlawful killing 1998 False 1997.630005 70-74 Women
203 1998-02-18 Maureen Alice Ward 57 Own home Conviction 1998 False 1997.640015 55-59 Women
204 1998-02-27 Joan Edwina Dean 75 Own home Unlawful killing 1998 False 1997.660034 75-79 Women
205 1998-03-04 Harold Eddleston 77 Own home Unlawful killing 1998 True 1997.670044 75-79 Men
206 1998-03-06 Margaret Anne Waldron 65 Own home Unlawful killing 1998 False 1997.680054 65-69 Women
207 1998-03-07 Irene Chapman 74 Own home Unlawful killing 1998 False 1997.680054 70-74 Women
208 1998-03-13 Dorothy Long 84 Own home Unlawful killing 1998 False 1997.699951 80-84 Women
209 1998-03-17 Lily Higgins 83 Own home Unlawful killing 1998 False 1997.709961 80-84 Women
210 1998-03-20 Ada Warburton 77 Own home Unlawful killing 1998 False 1997.719971 75-79 Women
211 1998-03-24 Martha Marley 88 Own home Unlawful killing 1998 False 1997.729980 85-89 Women
212 1998-05-11 Winifred Mellor 73 Own home Conviction 1998 False 1997.859985 70-74 Women
213 1998-06-12 Joan May Melia 73 Own home Conviction 1998 False 1997.949951 70-74 Women
214 1998-06-24 Kathleen Grundy 81 Own home Conviction 1998 False 1997.979980 80-84 Women

This part of the dataset describes the gender of the victims that Dr. Shipman killed.

In [3]:
query = """
SELECt age, gender2,count(*) as amount
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by age,gender2
  order by count(*) desc


  
 

"""
df = pd.read_sql_query(query, conn)


df
Out[3]:
age gender2 amount
0 84 Women 12
1 74 Women 11
2 81 Women 11
3 76 Women 9
4 77 Women 8
5 79 Women 8
6 73 Women 8
7 82 Women 8
8 75 Women 7
9 69 Women 7
10 70 Women 7
11 80 Women 7
12 78 Women 6
13 83 Women 6
14 85 Women 5
15 86 Women 5
16 87 Women 5
17 88 Women 5
18 71 Women 4
19 72 Women 4
20 68 Women 4
21 77 Men 4
22 85 Men 4
23 63 Women 4
24 67 Women 3
25 88 Men 3
26 82 Men 3
27 90 Women 3
28 89 Women 2
29 83 Men 2
30 73 Men 2
31 76 Men 2
32 81 Men 2
33 90 Men 2
34 51 Women 2
35 53 Women 2
36 54 Women 2
37 65 Women 2
38 57 Women 2
39 58 Women 1
40 59 Women 1
41 60 Women 1
42 64 Women 1
43 56 Women 1
44 47 Women 1
45 49 Women 1
46 75 Men 1
47 86 Men 1
48 87 Men 1
49 78 Men 1
50 79 Men 1
51 80 Men 1
52 41 Men 1
53 43 Men 1
54 47 Men 1
55 67 Men 1
56 69 Men 1
57 70 Men 1
58 72 Men 1
59 92 Women 1
60 93 Women 1
In [4]:
import plotly.express as px

gender= df['gender2']
age=df['age']



fig = px.pie(values=age, names=gender)
fig.update_layout(
    title=dict(text="Shipman's prefered victims were Women"), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()

Most of Shipman's victims were killed in the 1990s.

In [5]:
query = """
SELECT yearofDeath,count(yearofDeath) as number
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by yearofDeath



  
 

"""
df = pd.read_sql_query(query, conn)
df
Out[5]:
yearofDeath number
0 1975 1
1 1978 4
2 1979 2
3 1981 2
4 1983 2
5 1984 9
6 1985 11
7 1986 8
8 1987 8
9 1988 11
10 1989 12
11 1990 2
12 1992 1
13 1993 16
14 1994 11
15 1995 30
16 1996 30
17 1997 37
18 1998 18
In [6]:
import numpy
import plotly.express as px



# Random Data
names = df['yearofDeath']
x =   df['number']

fig = px.pie(values=x, names=names)
fig.update_layout(
    title=dict(text="Years when Shipman killed most of his victims."),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()

Shipman preferred place to kill his victims was their own home.

In [7]:
query = """
SELECT placeofdeath, count(placeofdeath) as [amount of deaths]
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by PlaceofDeath
  order by count(placeofdeath) desc


  
 

"""
df = pd.read_sql_query(query, conn)
df
Out[7]:
placeofdeath amount of deaths
0 Own home 204
1 Shipman's surgery 6
2 Residential Home 2
3 Hospital 2
4 Nursing home 1
In [8]:
import numpy
import plotly.express as px


# Random Data
names = df['placeofdeath']
x = df['amount of deaths']

fig = px.pie(values=x, names=names)
fig.update_layout(
    title=dict(text="Shipman killed most of his victims in their own home."), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()

Most of the Shipman's victims were between the ages of 60-85.

In [9]:
query = """
SELECt age, gender2,count(*) as amount
  FROM [practical_sql].[dbo].[shipman_confirmed_victims]
  group by age,gender2
  order by count(*) desc



  
 

"""
df = pd.read_sql_query(query, conn)
df
Out[9]:
age gender2 amount
0 84 Women 12
1 74 Women 11
2 81 Women 11
3 76 Women 9
4 77 Women 8
5 79 Women 8
6 73 Women 8
7 82 Women 8
8 75 Women 7
9 69 Women 7
10 70 Women 7
11 80 Women 7
12 78 Women 6
13 83 Women 6
14 85 Women 5
15 86 Women 5
16 87 Women 5
17 88 Women 5
18 71 Women 4
19 72 Women 4
20 68 Women 4
21 77 Men 4
22 85 Men 4
23 63 Women 4
24 67 Women 3
25 88 Men 3
26 82 Men 3
27 90 Women 3
28 89 Women 2
29 83 Men 2
30 73 Men 2
31 76 Men 2
32 81 Men 2
33 90 Men 2
34 51 Women 2
35 53 Women 2
36 54 Women 2
37 65 Women 2
38 57 Women 2
39 58 Women 1
40 59 Women 1
41 60 Women 1
42 64 Women 1
43 56 Women 1
44 47 Women 1
45 49 Women 1
46 75 Men 1
47 86 Men 1
48 87 Men 1
49 78 Men 1
50 79 Men 1
51 80 Men 1
52 41 Men 1
53 43 Men 1
54 47 Men 1
55 67 Men 1
56 69 Men 1
57 70 Men 1
58 72 Men 1
59 92 Women 1
60 93 Women 1
In [10]:
import plotly.express as px

age, gender = df["age"],df["gender2"]


 
fig = px.box(y = age, x=gender, points="all")
fig.update_layout(
    title=dict(text="Shipman's preferred victims were old old people"),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightpink",plot_bgcolor = "rgba(0,0,0,0)")
fig.update_layout(

    xaxis_title="Months",
    yaxis_title="Years ",
    legend_title="Legend Title"
)



fig.show()
In [11]:
query = """
SELECT YEAR([DateofDeath]) AS Year,
	   FORMAT([DateofDeath], 'MMMM') AS Month,
	   day([DateofDeath]) AS Day,
	   *         

 from [dbo].[shipman_confirmed_victims]
 


  
 

"""
df = pd.read_sql_query(query, conn)
df
Out[11]:
Year Month Day DateofDeath Name Age PlaceofDeath Decision yearOfDeath gender fractionalDeathYear ageBracket gender2
0 1975 March 17 1975-03-17 Eva Lyons 70 Own home Unlawful killing 1975 False 1974.709961 70-74 Women
1 1978 August 7 1978-08-07 Sarah Hannah Marsland 86 Own home Unlawful killing 1978 False 1978.099976 85-89 Women
2 1978 August 30 1978-08-30 Mary Ellen Jordan 73 Own home Unlawful killing 1978 False 1978.160034 70-74 Women
3 1978 December 7 1978-12-07 Harold Bramwell 73 Own home Unlawful killing 1978 True 1978.439941 70-74 Men
4 1978 December 20 1978-12-20 Annie Campbell 88 Own home Unlawful killing 1978 False 1978.469971 85-89 Women
5 1979 August 10 1979-08-10 Alice Maude Gorton 76 Own home Unlawful killing 1979 False 1979.109985 75-79 Women
6 1979 November 28 1979-11-28 Jack Leslie Shelmerdine 77 Hospital Unlawful killing 1979 True 1979.410034 75-79 Men
7 1981 April 18 1981-04-18 May Slater 84 Own home Unlawful killing 1981 False 1980.800049 80-84 Women
8 1981 August 26 1981-08-26 Elizabeth Ashworth 81 Own home Unlawful killing 1981 False 1981.150024 80-84 Women
9 1983 January 4 1983-01-04 Percy Ward 90 Own home Unlawful killing 1983 True 1982.510010 90-94 Men
10 1983 June 28 1983-06-28 Moira Ashton Fox 77 Own home Unlawful killing 1983 False 1982.989990 75-79 Women
11 1984 January 7 1984-01-07 Dorothy Tucker 51 Own home Unlawful killing 1984 False 1983.520020 50-54 Women
12 1984 February 8 1984-02-08 Gladys Roberts 78 Own home Unlawful killing 1984 False 1983.609985 75-79 Women
13 1984 April 15 1984-04-15 Joseph Bardsley 83 Own home Unlawful killing 1984 True 1983.790039 80-84 Men
14 1984 April 24 1984-04-24 Winifred Arrowsmith 70 Own home Unlawful killing 1984 False 1983.810059 70-74 Women
15 1984 September 21 1984-09-21 Mary Winterbottom 76 Own home Unlawful killing 1984 False 1984.219971 75-79 Women
16 1984 November 27 1984-11-27 Ada Ashworth 87 Own home Unlawful killing 1984 False 1984.410034 85-89 Women
17 1984 December 17 1984-12-17 Joseph Vincent Everall 80 Own home Unlawful killing 1984 True 1984.459961 80-84 Men
18 1984 December 18 1984-12-18 Edith Wibberley 76 Own home Unlawful killing 1984 False 1984.469971 75-79 Women
19 1984 December 24 1984-12-24 Eileen Theresa Cox 72 Own home Unlawful killing 1984 False 1984.479980 70-74 Women
20 1985 January 2 1985-01-02 Peter Lewis 41 Own home Unlawful killing 1985 True 1984.510010 40-44 Men
21 1985 February 1 1985-02-01 May Brookes 74 Own home Unlawful killing 1985 False 1984.589966 70-74 Women
22 1985 February 4 1985-02-04 Ellen Higson 84 Own home Unlawful killing 1985 False 1984.599976 80-84 Women
23 1985 February 15 1985-02-15 Margaret Ann Conway 69 Own home Unlawful killing 1985 False 1984.630005 65-69 Women
24 1985 February 22 1985-02-22 Kathleen McDonald 73 Own home Unlawful killing 1985 False 1984.650024 70-74 Women
25 1985 June 26 1985-06-26 Thomas Moult 70 Own home Unlawful killing 1985 True 1984.989990 70-74 Men
26 1985 June 26 1985-06-26 Mildred Robinson 84 Own home Unlawful killing 1985 False 1984.989990 80-84 Women
27 1985 August 23 1985-08-23 Frances Elizabeth Turner 85 Own home Unlawful killing 1985 False 1985.150024 85-89 Women
28 1985 December 17 1985-12-17 Selina Mackenzie 77 Own home Unlawful killing 1985 False 1985.459961 75-79 Women
29 1985 December 20 1985-12-20 Vera Bramwell 79 Own home Unlawful killing 1985 False 1985.469971 75-79 Women
30 1985 December 31 1985-12-31 Fred Kellett 79 Own home Unlawful killing 1985 True 1985.500000 75-79 Men
31 1986 January 7 1986-01-07 Deborah Middleton 81 Own home Unlawful killing 1986 False 1985.520020 80-84 Women
32 1986 April 23 1986-04-23 Dorothy Fletcher 74 Residential Home Unlawful killing 1986 False 1985.810059 70-74 Women
33 1986 June 6 1986-06-06 Thomas Fowden 81 Own home Unlawful killing 1986 True 1985.930054 80-84 Men
34 1986 September 15 1986-09-15 Mona Ashton White 63 Own home Unlawful killing 1986 False 1986.209961 60-64 Women
35 1986 October 7 1986-10-07 Mary Tomlin 73 Own home Unlawful killing 1986 False 1986.270020 70-74 Women
36 1986 November 17 1986-11-17 Beatrice Toft 59 Own home Unlawful killing 1986 False 1986.380005 55-59 Women
37 1986 December 16 1986-12-16 Lily Broadbent 75 Own home Unlawful killing 1986 False 1986.459961 75-79 Women
38 1986 December 23 1986-12-23 James Wood 82 Own home Unlawful killing 1986 True 1986.479980 80-84 Men
39 1987 March 30 1987-03-30 Frank Halliday 76 Own home Unlawful killing 1987 True 1986.750000 75-79 Men
40 1987 April 1 1987-04-01 Albert Cheetham 85 Own home Unlawful killing 1987 True 1986.750000 85-89 Men
41 1987 April 16 1987-04-16 Alice Thomas 83 Own home Unlawful killing 1987 False 1986.790039 80-84 Women
42 1987 May 8 1987-05-08 Jane Frances Rostron 78 Own home Unlawful killing 1987 False 1986.849976 75-79 Women
43 1987 September 14 1987-09-14 Nancy Anne Brassington 71 Own home Unlawful killing 1987 False 1987.209961 70-74 Women
44 1987 December 11 1987-12-11 Margaret Townsend 80 Own home Unlawful killing 1987 False 1987.449951 80-84 Women
45 1987 December 29 1987-12-29 Nellie Bardsley 69 Own home Unlawful killing 1987 False 1987.500000 65-69 Women
46 1987 December 30 1987-12-30 Elizabeth Ann Rogers 74 Own home Unlawful killing 1987 False 1987.500000 70-74 Women
47 1988 January 5 1988-01-05 Elizabeth Fletcher 90 Own home Unlawful killing 1988 False 1987.510010 90-94 Women
48 1988 January 15 1988-01-15 Alice Mary Jones 83 Own home Unlawful killing 1988 False 1987.540039 80-84 Women
49 1988 February 9 1988-02-09 Dorothea Hill Renwick 90 Own home Unlawful killing 1988 False 1987.609985 90-94 Women
50 1988 February 15 1988-02-15 Ann Cooper 93 Own home Unlawful killing 1988 False 1987.619995 90-94 Women
51 1988 February 15 1988-02-15 Jane Jones 83 Own home Unlawful killing 1988 False 1987.619995 80-84 Women
52 1988 February 16 1988-02-16 Lavinia Robinson 84 Own home Unlawful killing 1988 False 1987.630005 80-84 Women
53 1988 September 18 1988-09-18 Rose Ann Adshead 80 Own home Unlawful killing 1988 False 1988.219971 80-84 Women
54 1988 October 20 1988-10-20 Alice Prestwich 69 Own home Unlawful killing 1988 False 1988.300049 65-69 Women
55 1988 November 6 1988-11-06 Walter Tingle 85 Own home Unlawful killing 1988 True 1988.349976 85-89 Men
56 1988 December 17 1988-12-17 Harry Stafford 87 Own home Unlawful killing 1988 True 1988.459961 85-89 Men
57 1988 December 19 1988-12-19 Ethel Bennett 80 Own home Unlawful killing 1988 False 1988.469971 80-84 Women
58 1989 January 31 1989-01-31 Wilfred Chappell 80 Own home Unlawful killing 1989 False 1988.589966 80-84 Women
59 1989 March 8 1989-03-08 Mary Emma Hamer 81 Shipman's surgery Unlawful killing 1989 False 1988.680054 80-84 Women
60 1989 May 12 1989-05-12 Beatrice Helen Clee 78 Own home Unlawful killing 1989 False 1988.859985 75-79 Women
61 1989 June 5 1989-06-05 Josephine Hall 69 Own home Unlawful killing 1989 False 1988.930054 65-69 Women
62 1989 July 6 1989-07-06 Hilda Fitton 75 Own home Unlawful killing 1989 False 1989.010010 75-79 Women
63 1989 August 14 1989-08-14 Marion Carradice 80 Own home Unlawful killing 1989 False 1989.119995 80-84 Women
64 1989 September 22 1989-09-22 Elsie Harrop 82 Own home Unlawful killing 1989 False 1989.229980 80-84 Women
65 1989 September 26 1989-09-26 Elizabeth Mary Burke 82 Own home Unlawful killing 1989 False 1989.239990 80-84 Women
66 1989 October 15 1989-10-15 Sarah Jane Williamson 82 Own home Unlawful killing 1989 False 1989.290039 80-84 Women
67 1989 October 16 1989-10-16 John Charlton 81 Own home Unlawful killing 1989 True 1989.290039 80-84 Men
68 1989 October 18 1989-10-18 George Edgar Vizor 67 Own home Unlawful killing 1989 True 1989.300049 65-69 Men
69 1989 November 6 1989-11-06 Joseph Frank Wilcockson 85 Own home Unlawful killing 1989 True 1989.349976 85-89 Men
70 1990 September 18 1990-09-18 Dorothy Rowarth 56 Own home Unlawful killing 1990 False 1990.219971 55-59 Women
71 1990 December 30 1990-12-30 Mary Rose Dudley 69 Own home Unlawful killing 1990 False 1990.500000 65-69 Women
72 1992 October 7 1992-10-07 Monica Rene Sparkes 72 Own home Unlawful killing 1992 False 1992.270020 70-74 Women
73 1993 February 24 1993-02-24 Olive Heginbotham 86 Own home Unlawful killing 1993 False 1992.650024 85-89 Women
74 1993 February 24 1993-02-24 Hilda Mary Couzens 92 Own home Unlawful killing 1993 False 1992.650024 90-94 Women
75 1993 March 22 1993-03-22 Amy Whitehead 82 Own home Unlawful killing 1993 False 1992.719971 80-84 Women
76 1993 April 8 1993-04-08 Mary Emma Andrew 86 Own home Unlawful killing 1993 False 1992.770020 85-89 Women
77 1993 April 17 1993-04-17 Sarah Ashworth 74 Own home Unlawful killing 1993 False 1992.790039 70-74 Women
78 1993 April 26 1993-04-26 Fanny Nichols 84 Own home Unlawful killing 1993 False 1992.819946 80-84 Women
79 1993 April 27 1993-04-27 Marjorie Parker 74 Own home Unlawful killing 1993 False 1992.819946 70-74 Women
80 1993 May 2 1993-05-02 Nellie Mullen 77 Own home Unlawful killing 1993 False 1992.839966 75-79 Women
81 1993 May 4 1993-05-04 Edna May Llewellyn 68 Own home Unlawful killing 1993 False 1992.839966 65-69 Women
82 1993 May 12 1993-05-12 Emily Morgan 84 Own home Unlawful killing 1993 False 1992.859985 80-84 Women
83 1993 May 13 1993-05-13 Violet May Bird 60 Own home Unlawful killing 1993 False 1992.869995 60-64 Women
84 1993 July 22 1993-07-22 Jose Kathleen Diana Richards 74 Own home Unlawful killing 1993 False 1993.060059 70-74 Women
85 1993 August 16 1993-08-16 Edith Calverley 77 Own home Unlawful killing 1993 False 1993.130005 75-79 Women
86 1993 December 16 1993-12-16 Joseph Leigh 78 Own home Unlawful killing 1993 False 1993.459961 75-79 Women
87 1993 December 22 1993-12-22 Eileen Robinson 54 Own home Unlawful killing 1993 False 1993.479980 50-54 Women
88 1993 December 31 1993-12-31 Charles Edward Brocklehurst 90 Own home Unlawful killing 1993 True 1993.500000 90-94 Men
89 1994 January 4 1994-01-04 Joan Milray Harding 82 Shipman's surgery Unlawful killing 1994 False 1993.510010 80-84 Women
90 1994 January 13 1994-01-13 Christine Hancock 53 Own home Unlawful killing 1994 False 1993.540039 50-54 Women
91 1994 February 9 1994-02-09 Elsie Platt 73 Own home Unlawful killing 1994 False 1993.609985 70-74 Women
92 1994 May 17 1994-05-17 Mary Alice Smith 84 Own home Unlawful killing 1994 False 1993.880005 80-84 Women
93 1994 May 25 1994-05-25 Ronnie Devenport 57 Own home Unlawful killing 1994 False 1993.900024 55-59 Women
94 1994 June 15 1994-06-15 Cicely Sharples 87 Own home Unlawful killing 1994 False 1993.959961 85-89 Women
95 1994 June 17 1994-06-17 Alice Christine Kitchen 70 Own home Unlawful killing 1994 False 1993.959961 70-74 Women
96 1994 July 27 1994-07-27 Maria Thornton 78 Own home Unlawful killing 1994 False 1994.069946 75-79 Women
97 1994 November 25 1994-11-25 Henrietta Walker 87 Own home Unlawful killing 1994 False 1994.400024 85-89 Women
98 1994 November 30 1994-11-30 Elizabeth Ellen Mellor 75 Own home Unlawful killing 1994 False 1994.420044 75-79 Women
99 1994 December 29 1994-12-29 John Bennett Molesdale 81 Own home Unlawful killing 1994 False 1994.500000 80-84 Women
100 1995 January 9 1995-01-09 Alice Kennedy 88 Own home Unlawful killing 1995 False 1994.530029 85-89 Women
101 1995 March 1 1995-03-01 Lucy Virgin 70 Own home Unlawful killing 1995 False 1994.670044 70-74 Women
102 1995 March 3 1995-03-03 Joseph Shaw 88 Own home Unlawful killing 1995 True 1994.670044 85-89 Men
103 1995 March 6 1995-03-06 Maria West 81 Own home Conviction 1995 False 1994.680054 80-84 Women
104 1995 March 7 1995-03-07 Netta Ashcroft 71 Own home Unlawful killing 1995 False 1994.680054 70-74 Women
105 1995 March 7 1995-03-07 Lily Bardsley 88 Own home Unlawful killing 1995 False 1994.680054 85-89 Women
106 1995 March 13 1995-03-13 Marie Antoinette Fernley 53 Own home Unlawful killing 1995 False 1994.699951 50-54 Women
107 1995 March 21 1995-03-21 John Crompton 82 Own home Unlawful killing 1995 True 1994.719971 80-84 Men
108 1995 March 26 1995-03-26 Frank Crompton 86 Own home Unlawful killing 1995 True 1994.729980 85-89 Men
109 1995 March 31 1995-03-31 Vera Brocklehurst 70 Own home Unlawful killing 1995 False 1994.750000 70-74 Women
110 1995 April 10 1995-04-10 Angela Philomena Tierney 71 Own home Unlawful killing 1995 False 1994.780029 70-74 Women
111 1995 April 13 1995-04-13 Edith Scott 85 Own home Unlawful killing 1995 False 1994.780029 85-89 Women
112 1995 April 14 1995-04-14 Clara Hackney 84 Own home Unlawful killing 1995 False 1994.790039 80-84 Women
113 1995 April 21 1995-04-21 Renate Eldtraude Overton 47 Hospital Unlawful killing 1995 False 1994.810059 45-49 Women
114 1995 May 4 1995-05-04 Kate Maud Sellors 75 Own home Unlawful killing 1995 False 1994.839966 75-79 Women
115 1995 June 2 1995-06-02 Clifford Barnes Heapey 85 Nursing home Unlawful killing 1995 True 1994.920044 85-89 Men
116 1995 June 13 1995-06-13 Bertha Moss 68 Shipman's surgery Unlawful killing 1995 False 1994.949951 65-69 Women
117 1995 June 17 1995-06-17 Brenda Ashworth 63 Own home Unlawful killing 1995 False 1994.959961 60-64 Women
118 1995 June 29 1995-06-29 Ernest Rudol 82 Own home Unlawful killing 1995 False 1994.989990 80-84 Women
119 1995 July 12 1995-07-12 Ada Matley Hilton 88 Own home Unlawful killing 1995 False 1995.030029 85-89 Women
120 1995 July 31 1995-07-31 Irene Aitken 65 Own home Unlawful killing 1995 False 1995.079956 65-69 Women
121 1995 August 29 1995-08-29 Arthur Henderson Stopford 82 Own home Unlawful killing 1995 True 1995.160034 80-84 Men
122 1995 September 14 1995-09-14 Geoffrey Bogle 72 Own home Unlawful killing 1995 True 1995.209961 70-74 Men
123 1995 September 26 1995-09-26 Dora Elizabeth Ashton 87 Shipman's surgery Unlawful killing 1995 False 1995.239990 85-89 Women
124 1995 October 24 1995-10-24 Muriel Margaret Ward 87 Own home Unlawful killing 1995 False 1995.319946 85-89 Women
125 1995 November 8 1995-11-08 Edith Brock 74 Own home Unlawful killing 1995 False 1995.359985 70-74 Women
126 1995 November 22 1995-11-22 Charles Henry Barlow 88 Own home Unlawful killing 1995 True 1995.390015 85-89 Men
127 1995 November 25 1995-11-25 Konrad Peter Ovcar-Robinson 43 Own home Unlawful killing 1995 True 1995.400024 40-44 Men
128 1995 December 14 1995-12-14 Elizabeth Teresa Sigley 67 Own home Unlawful killing 1995 False 1995.449951 65-69 Women
129 1995 December 14 1995-12-14 Kenneth Wharmby Woodhead 75 Own home Unlawful killing 1995 True 1995.449951 75-79 Men
130 1996 January 2 1996-01-02 Hilda Mary Hibbert 81 Own home Unlawful killing 1996 False 1995.500000 80-84 Women
131 1996 January 11 1996-01-11 Erla Copeland 79 Own home Unlawful killing 1996 False 1995.530029 75-79 Women
132 1996 February 21 1996-02-21 Jane Elizabeth Shelmerdine 80 Own home Unlawful killing 1996 False 1995.640015 80-84 Women
133 1996 February 27 1996-02-27 John Sheard Greenhalgh 88 Own home Unlawful killing 1996 True 1995.660034 85-89 Men
134 1996 March 12 1996-03-12 Minnie Doris Irene Galpin 71 Own home Unlawful killing 1996 False 1995.699951 70-74 Women
135 1996 April 18 1996-04-18 Marjorie Hope Waller 79 Own home Unlawful killing 1996 False 1995.800049 75-79 Women
136 1996 April 24 1996-04-24 John Stone 77 Own home Unlawful killing 1996 True 1995.810059 75-79 Men
137 1996 May 7 1996-05-07 Elsie Godfrey 85 Own home Unlawful killing 1996 False 1995.849976 85-89 Women
138 1996 May 13 1996-05-13 Edith Brady 72 Shipman's surgery Unlawful killing 1996 False 1995.869995 70-74 Women
139 1996 May 29 1996-05-29 Valerie Cuthbert 54 Own home Unlawful killing 1996 False 1995.910034 50-54 Women
140 1996 May 30 1996-05-30 Lilian Cullen 77 Own home Unlawful killing 1996 False 1995.910034 75-79 Women
141 1996 June 6 1996-06-06 Renee Lacey 63 Own home Unlawful killing 1996 False 1995.930054 60-64 Women
142 1996 June 10 1996-06-10 Leah Fogg 82 Own home Unlawful killing 1996 False 1995.939941 80-84 Women
143 1996 June 17 1996-06-17 Gladys Saunders 82 Own home Unlawful killing 1996 False 1995.959961 80-84 Women
144 1996 June 25 1996-06-25 Nellie Bennett 86 Own home Unlawful killing 1996 False 1995.979980 85-89 Women
145 1996 June 25 1996-06-25 Margaret Mary Vickers 81 Own home Unlawful killing 1996 False 1995.979980 80-84 Women
146 1996 July 2 1996-07-02 Tom Balfour Russell 77 Own home Unlawful killing 1996 True 1996.000000 75-79 Men
147 1996 July 11 1996-07-11 Irene Turner 67 Own home Conviction 1996 False 1996.030029 65-69 Women
148 1996 July 16 1996-07-16 Carrie Leigh 81 Own home Unlawful killing 1996 False 1996.040039 80-84 Women
149 1996 July 19 1996-07-19 Marion Elizabeth Higham 84 Own home Unlawful killing 1996 False 1996.050049 80-84 Women
150 1996 July 24 1996-07-24 Elsie Hannible 85 Own home Unlawful killing 1996 False 1996.060059 85-89 Women
151 1996 July 29 1996-07-29 Elsie Barker 84 Own home Unlawful killing 1996 False 1996.079956 80-84 Women
152 1996 August 30 1996-08-30 Sidney Arthur Smith 76 Own home Unlawful killing 1996 True 1996.160034 75-79 Men
153 1996 September 12 1996-09-12 Dorothy Mary Andrew 85 Own home Unlawful killing 1996 False 1996.199951 85-89 Women
154 1996 September 20 1996-09-20 Anne Lilian Ralphs 75 Own home Unlawful killing 1996 False 1996.219971 75-79 Women
155 1996 October 23 1996-10-23 Millicent Garside 76 Own home Unlawful killing 1996 False 1996.310059 75-79 Women
156 1996 November 20 1996-11-20 Irene Heathcote 76 Own home Unlawful killing 1996 False 1996.390015 75-79 Women
157 1996 November 23 1996-11-23 Samuel Mills 89 Own home Unlawful killing 1996 False 1996.400024 85-89 Women
158 1996 December 4 1996-12-04 Thomas Cheetham 78 Own home Unlawful killing 1996 True 1996.430054 75-79 Men
159 1996 December 17 1996-12-17 Kenneth Ernest Smith 73 Own home Unlawful killing 1996 True 1996.459961 70-74 Men
160 1997 January 2 1997-01-02 Eileen Daphne Crompton 75 Residential home Unlawful killing 1997 False 1996.510010 75-79 Women
161 1997 January 3 1997-01-03 David Alan Harrison 47 Own home Unlawful killing 1997 True 1996.510010 45-49 Men
162 1997 January 8 1997-01-08 Elsie Lorna Dean 69 Own home Unlawful killing 1997 False 1996.520020 65-69 Women
163 1997 January 20 1997-01-20 Irene Brooder 76 Own home Unlawful killing 1997 False 1996.560059 75-79 Women
164 1997 January 27 1997-01-27 Charlotte Bennison 89 Own home Unlawful killing 1997 False 1996.579956 85-89 Women
165 1997 February 3 1997-02-03 Charles Henry Killan 90 Own home Unlawful killing 1997 False 1996.589966 90-94 Women
166 1997 February 4 1997-02-04 Betty Royston 70 Own home Unlawful killing 1997 False 1996.599976 70-74 Women
167 1997 February 23 1997-02-23 Joyce Woodhead 74 Own home Unlawful killing 1997 False 1996.650024 70-74 Women
168 1997 February 28 1997-02-28 Lizzie Adams 77 Own home Conviction 1997 False 1996.660034 75-79 Women
169 1997 March 22 1997-03-22 Rose Garlick 76 Own home Unlawful killing 1997 False 1996.719971 75-79 Women
170 1997 March 27 1997-03-27 May Lowe 84 Own home Unlawful killing 1997 False 1996.739990 80-84 Women
171 1997 April 21 1997-04-21 Mary Coutts 80 Own home Unlawful killing 1997 False 1996.810059 80-84 Women
172 1997 April 25 1997-04-25 Elsie Cheetham 76 Own home Unlawful killing 1997 False 1996.819946 75-79 Women
173 1997 April 25 1997-04-25 Jean Lilley 58 Own home Conviction 1997 False 1996.819946 55-59 Women
174 1997 May 2 1997-05-02 Lena Norah Slater 68 Own home Unlawful killing 1997 False 1996.839966 65-69 Women
175 1997 May 12 1997-05-12 Ethel May Kellett 74 Own home Unlawful killing 1997 False 1996.859985 70-74 Women
176 1997 May 21 1997-05-21 Doris Earls 79 Own home Unlawful killing 1997 False 1996.890015 75-79 Women
177 1997 May 29 1997-05-29 Ivy Lomas 63 Shipman's surgery Conviction 1997 False 1996.910034 60-64 Women
178 1997 June 24 1997-06-24 Vera Whittingslow 69 Own home Unlawful killing 1997 False 1996.979980 65-69 Women
179 1997 July 7 1997-07-07 Maureen Lamonnier Jackson 51 Own home Unlawful killing 1997 False 1997.020020 50-54 Women
180 1997 July 14 1997-07-14 Muriel Grimshaw 76 Own home Conviction 1997 False 1997.040039 75-79 Women
181 1997 July 25 1997-07-25 John Louden Livesey 69 Own home Unlawful killing 1997 True 1997.069946 65-69 Men
182 1997 July 28 1997-07-28 Lily Newby Taylor 86 Own home Unlawful killing 1997 False 1997.069946 85-89 Women
183 1997 August 10 1997-08-10 Dorothy Doretta Hopkins 72 Own home Unlawful killing 1997 False 1997.109985 70-74 Women
184 1997 September 1 1997-09-01 Nancy Jackson 81 Own home Unlawful killing 1997 False 1997.170044 80-84 Women
185 1997 September 22 1997-09-22 Mavis Mary Pickup 79 Own home Unlawful killing 1997 False 1997.229980 75-79 Women
186 1997 September 26 1997-09-26 Bessie Swann 79 Own home Unlawful killing 1997 False 1997.239990 75-79 Women
187 1997 September 29 1997-09-29 Enid Otter 77 Own home Unlawful killing 1997 False 1997.250000 75-79 Women
188 1997 November 10 1997-11-10 Florence Lewis 79 Own home Unlawful killing 1997 False 1997.359985 75-79 Women
189 1997 November 14 1997-11-14 Mary Walls 78 Own home Unlawful killing 1997 False 1997.369995 75-79 Women
190 1997 November 21 1997-11-21 Elizabeth Mary Baddeley 83 Own home Unlawful killing 1997 False 1997.390015 80-84 Women
191 1997 November 24 1997-11-24 Marie Quinn 67 Own home Conviction 1997 False 1997.400024 65-69 Women
192 1997 December 8 1997-12-08 Elizabeth Battersby 70 Own home Unlawful killing 1997 False 1997.439941 70-74 Women
193 1997 December 9 1997-12-09 Laura Kathleen Wagstaff 81 Own home Conviction 1997 False 1997.439941 80-84 Women
194 1997 December 10 1997-12-10 Bianka Pomfret 49 Own home Conviction 1997 False 1997.439941 45-49 Women
195 1997 December 18 1997-12-18 Alice Black 73 Own home Unlawful killing 1997 False 1997.469971 70-74 Women
196 1997 December 24 1997-12-24 James Joseph King 83 Own home Unlawful killing 1997 True 1997.479980 80-84 Men
197 1998 January 22 1998-01-22 Mabel Shawcross 79 Own home Unlawful killing 1998 False 1997.560059 75-79 Women
198 1998 January 26 1998-01-26 Norah Nuttall 64 Own home Conviction 1998 False 1997.569946 60-64 Women
199 1998 February 2 1998-02-02 Cissie Davies 73 Own home Unlawful killing 1998 False 1997.589966 70-74 Women
200 1998 February 9 1998-02-09 Pamela Marguerite Hillier 68 Own home Conviction 1998 False 1997.609985 65-69 Women
201 1998 February 13 1998-02-13 Laura Frances Linn 83 Own home Unlawful killing 1998 False 1997.619995 80-84 Women
202 1998 February 15 1998-02-15 Irene Berry 74 Own home Unlawful killing 1998 False 1997.630005 70-74 Women
203 1998 February 18 1998-02-18 Maureen Alice Ward 57 Own home Conviction 1998 False 1997.640015 55-59 Women
204 1998 February 27 1998-02-27 Joan Edwina Dean 75 Own home Unlawful killing 1998 False 1997.660034 75-79 Women
205 1998 March 4 1998-03-04 Harold Eddleston 77 Own home Unlawful killing 1998 True 1997.670044 75-79 Men
206 1998 March 6 1998-03-06 Margaret Anne Waldron 65 Own home Unlawful killing 1998 False 1997.680054 65-69 Women
207 1998 March 7 1998-03-07 Irene Chapman 74 Own home Unlawful killing 1998 False 1997.680054 70-74 Women
208 1998 March 13 1998-03-13 Dorothy Long 84 Own home Unlawful killing 1998 False 1997.699951 80-84 Women
209 1998 March 17 1998-03-17 Lily Higgins 83 Own home Unlawful killing 1998 False 1997.709961 80-84 Women
210 1998 March 20 1998-03-20 Ada Warburton 77 Own home Unlawful killing 1998 False 1997.719971 75-79 Women
211 1998 March 24 1998-03-24 Martha Marley 88 Own home Unlawful killing 1998 False 1997.729980 85-89 Women
212 1998 May 11 1998-05-11 Winifred Mellor 73 Own home Conviction 1998 False 1997.859985 70-74 Women
213 1998 June 12 1998-06-12 Joan May Melia 73 Own home Conviction 1998 False 1997.949951 70-74 Women
214 1998 June 24 1998-06-24 Kathleen Grundy 81 Own home Conviction 1998 False 1997.979980 80-84 Women

Shipman killed most of his victims diring fall time, especially December.

In [12]:
month=df["Month"]
year = df["Year"]
fig = px.box(x=month, y=year)
fig.update_layout(title=dict(text="Shipman's killings per months in a spam or more than 3 decades"), font=dict(size=15))
fig.update_layout(paper_bgcolor="lightpink", plot_bgcolor="rgba(0,0,0,0)")


fig.update_layout(
   
    xaxis_title="Months",
    yaxis_title="Years ",
    legend_title="Legend Title"
    )






fig.show()

End of the Analysis

In [13]:
cursor = conn.cursor()
cursor.close()
print("Connection has been closed!!")
Connection has been closed!!
In [ ]: